package com.efast.dmom.mgmt.dao.excel;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.efast.dmom.mgmt.bean.excel.ExcelFieldAcceptBean;
import com.efast.dmom.mgmt.bean.excel.ExcelRuleDataBean;

/**
 * Excel配置规则界面
 * @author wj
 * 2019/10/10
 *
 */
public interface ExcelUploadRuleConfigurationDao {

	//模糊查询出来需要的表名
	public List<String> getTableName(@Param("name")String name);

	//通过表名查询出来对应的字段名和字段值
	public List<ExcelFieldAcceptBean> getFiledNameAndcommentByTableName(@Param("tableName") String tableName);
	
	//通过表名查询出来对应的字段名
	public List<String> getFiledNameByTableName(@Param("tableName") String tableName);

	//通过表名判断该表名对应下的规则是否存在
	public List<ExcelRuleDataBean> selectExcelRuleByTableName(@Param("tableName") String tableName);

	//通过上传的数据生成相应表的规则
	public void insertTwExcelRuleByData(@Param("tableName") String tableName,@Param("ruleData") List<ExcelRuleDataBean> ruleData);

	//更新修改的规则数据
	public void updateTableExcelRule(@Param("tableName") String tableName,@Param("ruleData") List<ExcelRuleDataBean> ruleData);

	//删除规则表的信息
	public void deleteTableExcelRule(@Param("tableName") String tableName,@Param("ruleData") List<ExcelRuleDataBean> ruleData);

}
